﻿using FreeSqlDemo.Services;
using Magicodes.ExporterAndImporter.Core;
using Magicodes.ExporterAndImporter.Excel;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;

namespace Magicodes.IE.Demo.Dto
{

    /**
    Name    名称(比如当前Sheet 名称)
    HeaderFontSize   头部字体大小
    FontSize    正文字体大小
    MaxRowNumberOnASheet   一个Sheet最大允许的行数，设置了之后将输出多个Sheet
    AutoFitAllColumn   自适应所有列
    AutoFitMaxRows    数据超过此行之后不启用自适应，默认关闭 
    Author     作者 
    ExporterHeaderFilter    头部筛选器
    IsDisableAllFilter     是否禁用所有筛选器
     */

    [ExcelExporter(Name = "学生信息", TableStyle = OfficeOpenXml.Table.TableStyles.Medium7,
    AutoFitAllColumn = true,
    ExporterHeaderFilter = typeof(ExporterStudentHeaderFilter))]

    public class ImportUserInfoDto
    {
        /// <summary>
        /// 学生编号
        /// </summary>
        [ExporterHeader(DisplayName = "学生编号")]
        public int? Id { get; set; }

        /// <summary>
        /// 学生姓名
        /// </summary>
        [ExporterHeader(DisplayName = "姓名")]
        public string UserName { get; set; }

        /// <summary>
        /// 学生性别
        /// </summary>
        /// 
        [ExporterHeader(DisplayName = "性别")]
        public string Sex { get; set; }

        /// <summary>
        /// 学生联系电话
        /// </summary>
        /// 
        [ExporterHeader(DisplayName = "联系电话")]
        public string Phone { get; set; }

        /// <summary>
        /// 学生描述
        /// </summary>
        [ExporterHeader(DisplayName = "描述")]
        public string Description { get; set; }

        /// <summary>
        /// 学生爱好
        /// </summary>
        [ExporterHeader(DisplayName = "爱好")]
        public string Hobby { get; set; }
    }
}
